package com.ktjiaoyu.server.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ktjiaoyu.server.pojo.Employee;
import org.apache.ibatis.annotations.Param;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author jjx
 * @since 2024-01-23
 */
public interface EmployeeMapper extends BaseMapper<Employee> {
    // 分页显示员工基本资料列表, 并按员工名模糊查询及政治面貌、部门、入职时间查询
    IPage<Employee> selectByPage(Page<Employee> page,
                                 @Param("query") String query,
                                 @Param("sort") String sort,
                                 @Param("politicsId") Integer politicsId,
                                 @Param("deptId") Integer deptId,
                                 @Param("beginTime") String beginTime,
                                 @Param("endTime") String endTime);

}
